Release 10.1A: OpenEdge Data Management:
SQL Reference

ALTER USER

Changes the password for the specified user.

Syntax

ALTER USER 'username', 'old_password', 'new_password' ;

Example

In this example, the ALTER USER statement Jasper changes the Jasper account password from normandy to brittany:

ALTER USER 'Jasper', 'normandy', 'brittany' ;

Notes

Used in conjunction with CREATE USER and DROP USER, the ALTER USER statement provides a way to change a user password.
The old_password specification must match the current password for username.

Authorization

User specified in username.

Related statements

CREATE USER, DROP USER